{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2020"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2020","index":0,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,14],[1,16,1,17],[1,18,1,19],[1,20,1,21]]}
[]
[null,"2021 YILI PERSONEL İZİN TABLOSU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.İzin",null,"2.İzin",null,"3.İzin"]
[null,"Sıra\nno.","Adı Soyadı","Bölümü\nÜnvanı","Doğum tarihi","Yaşı","İşe giriş Tarihi","Çalışma\nsüresi\n(yıl)","İzin hak\nediş tarihi","Geçmiş\nyıllarda\nkalan izni",null,"2020 yılı hak\nettiği / edeceği\nizin","Toplam\nbiriken\nizni","Toplam\nkullandığı\nİzin","Kalan\nizin",null,"Tarih","Gün","Tarih","Gün","Tarih","Gün"]
[null,1,"ESİN KILIÇ",null,"1977-05-01",{"$f":"(YEAR(TODAY())-YEAR(E4))*SIGN(E4)","v":44},"2001-10-26",{"$f":"(YEAR(TODAY())-YEAR(G4))*SIGN(G4)","v":20},{"$f":"DATE(YEAR(G4)+1,MONTH(G4),DAY(G4)+1)","v":"2002-10-27"},0,{"$f":"IF(H4>=1,LOOKUP(H4,{1,6,15},{14,20,26}),0)","v":26},{"$f":"IF(OR(H4>=50,H4<=18),20,K4)","v":26},{"$f":"J4+K4","v":26},{"$f":"R4+T4+V4","v":14},{"$f":"M4-N4","v":12},null,"2021-01-11",3,"2021-03-11",5,"2021-06-11",6]
[null,2,"ÇETİN KTILIÇ",null,"1977-01-01",{"$f":"(YEAR(TODAY())-YEAR(E5))*SIGN(E5)","v":44},"2015-12-01",6,{"$f":"DATE(YEAR(G5)+1,MONTH(G5),DAY(G5)+1)","v":"2016-12-02"},0,{"$f":"IF(H5>=1,LOOKUP(H5,{1,6,15},{14,20,26}),0)","v":20},{"$f":"IF(OR(H5>=50,H5<=18),20,K5)","v":20},{"$f":"J5+K5","v":20},{"$f":"R5+T5+V5","v":0},{"$f":"M5-N5","v":20}]
[null,3,"ATAKAN KILIÇ",null,"1976-12-28",{"$f":"(YEAR(TODAY())-YEAR(E6))*SIGN(E6)","v":45},"2015-12-02",6,"2016-12-03",0,{"$f":"IF(H6>=1,LOOKUP(H6,{1,6,15},{14,20,26}),0)","v":20},{"$f":"IF(OR(H6>=50,H6<=18),20,K6)","v":20},{"$f":"J6+K6","v":20},0,20]
[null,4,"ATALAY KILIÇ",null,"1979-03-02",{"$f":"(YEAR(TODAY())-YEAR(E7))*SIGN(E7)","v":42},"2017-09-11",4,"2018-09-12",0,{"$f":"IF(H7>=1,LOOKUP(H7,{1,6,15},{14,20,26}),0)","v":14},20,{"$f":"J7+K7","v":14},0,14]
[null,5,null,null,"1979-08-15",42,"2018-02-02",3,"2019-02-03",0,{"$f":"IF(H8>=1,LOOKUP(H8,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[null,6,null,null,"1991-08-12",30,"2015-08-12",6,"2016-08-13",0,{"$f":"IF(H9>=1,LOOKUP(H9,{1,6,15},{14,20,26}),0)","v":20},20,20,0,20]
[null,7,null,null,"1991-03-06",30,"2018-02-01",3,"2019-02-02",0,{"$f":"IF(H10>=1,LOOKUP(H10,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[null,8,null,null,"1987-11-02",34,"2018-04-10",3,"2019-04-11",0,{"$f":"IF(H11>=1,LOOKUP(H11,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[null,9,null,null,"1987-03-03",34,"2018-07-13",3,"2019-07-14",0,{"$f":"IF(H12>=1,LOOKUP(H12,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[null,10,null,null,"1989-08-30",32,"2018-11-09",3,"2019-11-10",0,{"$f":"IF(H13>=1,LOOKUP(H13,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[null,11,null,null,"1983-05-20",38,"2018-07-01",3,"2019-07-02",0,{"$f":"IF(H14>=1,LOOKUP(H14,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[null,12,null,null,"1989-09-28",32,"2020-04-01",1,"2021-04-02",0,{"$f":"IF(H15>=1,LOOKUP(H15,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[null,13,null,null,"1982-03-22",39,"2019-06-24",{"$f":"(YEAR(TODAY())-YEAR(G16))*SIGN(G16)","v":2},{"$f":"DATE(YEAR(G16)+1,MONTH(G16),DAY(G16)+1)","v":"2020-06-25"},0,{"$f":"IF(H16>=1,LOOKUP(H16,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[null,14,null,null,"1977-06-27",44,"2017-09-11",4,"2018-09-12",0,{"$f":"IF(H17>=1,LOOKUP(H17,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[null,15,null,null,"1983-09-25",38,"2017-04-07",4,{"$f":"DATE(YEAR(G18)+1,MONTH(G18),DAY(G18)+1)","v":"2018-04-08"},0,{"$f":"IF(H18>=1,LOOKUP(H18,{1,6,15},{14,20,26}),0)","v":14},20,14,0,14]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Esin KILIÇ"]